/*河南星辰软件科技有限公司
@copyright Copyright (c) 2010~2022 All rights reserved.
*/
package cn.javaxc.psi.action.main;
import java.io.*;
import java.util.*;
import java.sql.*;
import cn.javaxc.model.base.SQL;
import cn.javaxc.model.base.SQLList;
import cn.javaxc.model.base.SQLMap;
import cn.javaxc.model.base.SQLParam;
import cn.javaxc.model.page.BatisPage;
import cn.javaxc.mvcwork.controller.web.TreeBean;
import cn.javaxc.mvcwork.util.common.CommonUtil;
import cn.javaxc.mvcwork.util.common.MapListUtil;
import cn.javaxc.mvcwork.util.helper.FrameHelper;
import cn.javaxc.mvcwork.util.helper.TreeTableHelper;
import org.springframework.beans.factory.annotation.Autowired;
import cn.javaxc.mvcwork.controller.GenericValidator;
import cn.javaxc.mvcwork.controller.AppUtils;
import cn.javaxc.system.action.base.BaseAction;
import cn.javaxc.psi.mapper.main.InventoryMapper;
public class InventoryAction extends BaseAction
{
    @Autowired(required=false)
	private InventoryMapper mapper;
    /**
    盘存列表
    */
    
    public Map inventoryList() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_firm=mapper.s_firm(params);
        s_firm.setSelectNone("所有");
        result.put("s_firm", s_firm);
        
        
        SQLList<SQLMap> p_quote=mapper.p_quote(params,pagination);
        p_quote.setPagedListInfo(pagination);
        result.put("p_quote", p_quote);
        
        return result;
    }
    /**
    盘存增加
    */
    
    public Map inventoryAdd() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_firm=mapper.s_firm(params);
        result.put("s_firm", s_firm);
        
        
        params.def("CMSEL",-1);
        SQLList<SQLMap> s_set=mapper.s_set(params);
        result.put("s_set", s_set);
        
        
        SQLList<SQLMap> s_inventory=mapper.s_inventory(params);
        result.put("s_inventory", s_inventory);
        
        return result;
    }
    /**
    盘存详情
    */
    
    public Map inventoryDetailsSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_quote=mapper.t_quote(params);
        SQLMap t_quote_emt=t_quote.getExistfirst();
        result.put("t_quote", t_quote_emt);
        
        
        SQLList<SQLMap> p_product=mapper.p_product(params,pagination);
        p_product.setPagedListInfo(pagination);
        result.put("p_product", p_product);
        
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        return result;
    }
    /**
    盘存物料
    */
    
    public Map inventoryPro() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_recod=new SQLList();
        result.put("s_recod", s_recod);
        
        return result;
    }
    /**
    搜索增加物料
    */
    
    public Map searchPro() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        TreeBean tb;
        
        tb = createTreeBean("l_class_treecols");
        tb.setPrefix("img");
        tb.setPid(1);
        SQLList<SQLMap> l_class=mapper.l_class(params);
        l_class = l_class.buildTree(tb,tb.getPid());
        result.put("l_class", l_class);
        
        
        SQLList<SQLMap> s_produce_series=mapper.s_produce_series(params);
        result.put("s_produce_series", s_produce_series);
        
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_goods=mapper.s_goods(params,pagination);
        s_goods.setPagedListInfo(pagination);
        result.put("s_goods", s_goods);
        
        return result;
    }
    /**
    替换库管员
    */
    
    public Map replaceLib() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_recod=mapper.t_recod(params);
        SQLMap t_recod_emt=t_recod.getExistfirst();
        result.put("t_recod", t_recod_emt);
        
        
        SQLList<SQLMap> s_info=mapper.s_info(params);
        result.put("s_info", s_info);
        
        return result;
    }
    /**
    库管员
    */
    
    public Map serchLib() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        TreeBean tb;
        
        SQLList<SQLMap> person_info=mapper.person_info(params,pagination);
        person_info.setPagedListInfo(pagination);
        result.put("person_info", person_info);
        
        
        
        
        SQLList<SQLMap> parent=mapper.parent(params);
        SQLMap parent_emt=parent.getExistfirst();
        result.put("parent", parent_emt);
        
        
        tb = createTreeBean("l_firm_treecols");
        tb.setPrefix("img");
        SQLList<SQLMap> l_firm=mapper.l_firm(params);
        l_firm = l_firm.buildTree(tb,tb.getPid());
        result.put("l_firm", l_firm);
        
        return result;
    }
    /**
    盘存执行详情
    */
    
    public Map inventoryDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_quote=mapper.t_quote(params);
        SQLMap t_quote_emt=t_quote.getExistfirst();
        result.put("t_quote", t_quote_emt);
        
        
        SQLList<SQLMap> s_step=mapper.s_step(params);
        result.put("s_step", s_step);
        
        return result;
    }
    /**
    盘存报告
    */
    
    public Map inventoryStatementSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> p_product=mapper.p_product(params,pagination);
        p_product.setPagedListInfo(pagination);
        result.put("p_product", p_product);
        
        return result;
    }
    /**
    报告详情
    */
    
    public Map reportDetailsSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        
        SQLList<SQLMap> s_pstock=mapper.s_pstock(params,pagination);
        s_pstock.setPagedListInfo(pagination);
        result.put("s_pstock", s_pstock);
        
        return result;
    }
    /**
    盘存执行列表
    */
    
    public Map inventoryImp() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_quote=mapper.t_quote(params);
        SQLMap t_quote_emt=t_quote.getExistfirst();
        result.put("t_quote", t_quote_emt);
        
        
        SQLList<SQLMap> p_product=mapper.p_product(params,pagination);
        p_product.setPagedListInfo(pagination);
        result.put("p_product", p_product);
        
        return result;
    }
    /**
    盘存物料详情
    */
    
    public Map proDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        return result;
    }
    /**
    差异报告列表
    */
    
    public Map diffRep() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_quote=mapper.t_quote(params);
        SQLMap t_quote_emt=t_quote.getExistfirst();
        result.put("t_quote", t_quote_emt);
        
        
        SQLList<SQLMap> p_product=mapper.p_product(params,pagination);
        p_product.setPagedListInfo(pagination);
        result.put("p_product", p_product);
        
        return result;
    }
    /**
    差异报告详情
    */
    
    public Map differenceReportDetails() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        return result;
    }
    /**
    库管员处理列表
    */
    
    public Map inventoryLibDiff() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_quote=mapper.t_quote(params);
        SQLMap t_quote_emt=t_quote.getExistfirst();
        result.put("t_quote", t_quote_emt);
        
        
        SQLList<SQLMap> p_product=mapper.p_product(params,pagination);
        p_product.setPagedListInfo(pagination);
        result.put("p_product", p_product);
        
        return result;
    }
    /**
    库管员查看关联
    */
    
    public Map viewAssociationSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        
        SQLList<SQLMap> s_pstock=mapper.s_pstock(params,pagination);
        s_pstock.setPagedListInfo(pagination);
        result.put("s_pstock", s_pstock);
        
        return result;
    }
    /**
    库管员选择出入单
    */
    
    public Map choiceEntryExit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        
        SQLList<SQLMap> s_recod=mapper.s_recod(params,pagination);
        s_recod.setPagedListInfo(pagination);
        result.put("s_recod", s_recod);
        
        return result;
    }
    /**
    库管组长处理列表
    */
    
    public Map inventoryLeaProHab() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_quote=mapper.t_quote(params);
        SQLMap t_quote_emt=t_quote.getExistfirst();
        result.put("t_quote", t_quote_emt);
        
        
        SQLList<SQLMap> p_product=mapper.p_product(params,pagination);
        p_product.setPagedListInfo(pagination);
        result.put("p_product", p_product);
        
        return result;
    }
    /**
    库管组长查看详情
    */
    
    public Map organizeInventoryDetails() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        
        SQLList<SQLMap> s_pstock=mapper.s_pstock(params,pagination);
        s_pstock.setPagedListInfo(pagination);
        result.put("s_pstock", s_pstock);
        
        return result;
    }
    /**
    财务经理审批列表
    */
    
    public Map finManApr() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_quote=mapper.t_quote(params);
        SQLMap t_quote_emt=t_quote.getExistfirst();
        result.put("t_quote", t_quote_emt);
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params);
        result.put("s_product", s_product);
        
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        return result;
    }
    /**
    财务经理审批详情
    */
    
    public Map financialApprovalDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        
        SQLList<SQLMap> s_pstock=mapper.s_pstock(params,pagination);
        s_pstock.setPagedListInfo(pagination);
        result.put("s_pstock", s_pstock);
        
        return result;
    }
    /**
    成本会计处理列表
    */
    
    public Map accoutTrea() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_quote=mapper.t_quote(params);
        SQLMap t_quote_emt=t_quote.getExistfirst();
        result.put("t_quote", t_quote_emt);
        
        
        SQLList<SQLMap> p_product=mapper.p_product(params,pagination);
        p_product.setPagedListInfo(pagination);
        result.put("p_product", p_product);
        
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        return result;
    }
    /**
    会计查看出入单
    */
    
    public Map approvalEntryExit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        
        SQLList<SQLMap> s_pstock=mapper.s_pstock(params,pagination);
        s_pstock.setPagedListInfo(pagination);
        result.put("s_pstock", s_pstock);
        
        return result;
    }
    /**
    会计选择出入单
    */
    
    public Map approvalChioceEntryExit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        
        SQLList<SQLMap> s_recod=mapper.s_recod(params,pagination);
        s_recod.setPagedListInfo(pagination);
        result.put("s_recod", s_recod);
        
        return result;
    }
    /**
    财务经理确认列表
    */
    
    public Map finManConfirm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_quote=mapper.t_quote(params);
        SQLMap t_quote_emt=t_quote.getExistfirst();
        result.put("t_quote", t_quote_emt);
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params);
        result.put("s_product", s_product);
        
        return result;
    }
    /**
    财务经理确认详情
    */
    
    public Map financialConfirmDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        
        SQLList<SQLMap> s_pstock=mapper.s_pstock(params,pagination);
        s_pstock.setPagedListInfo(pagination);
        result.put("s_pstock", s_pstock);
        
        return result;
    }
    /**
    盘存记录明细
    */
    
    public Map inventoryDet2() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_quote=mapper.s_quote(params);
        SQLMap s_quote_emt=s_quote.getExistfirst();
        result.put("s_quote", s_quote_emt);
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params);
        result.put("s_product", s_product);
        
        return result;
    }
    /**
    盘存记录修改
    */
    
    public Map inventoryUp() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_quote=mapper.s_quote(params);
        SQLMap s_quote_emt=s_quote.getExistfirst();
        result.put("s_quote", s_quote_emt);
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params);
        result.put("s_product", s_product);
        
        return result;
    }
    /**
    盘存记录详情修改
    */
    
    public Map inventoryUpDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_quote=mapper.s_quote(params);
        SQLMap s_quote_emt=s_quote.getExistfirst();
        result.put("s_quote", s_quote_emt);
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params);
        SQLMap s_product_emt=s_product.getExistfirst();
        result.put("s_product", s_product_emt);
        
        return result;
    }
    /**
    盘存
    */
    
    public Map inventoryTask() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        TreeBean tb;
        
        tb = createTreeBean("l_class_treecols");
        tb.setPrefix("img");
        SQLList<SQLMap> l_class=mapper.l_class(params);
        l_class = l_class.buildTree(tb,tb.getPid());
        result.put("l_class", l_class);
        
        
        tb = createTreeBean("l_firm_treecols");
        tb.setPrefix("img");
        SQLList<SQLMap> l_firm=mapper.l_firm(params);
        l_firm = l_firm.buildTree(tb,tb.getPid());
        result.put("l_firm", l_firm);
        
        
        SQLList<SQLMap> s_firm=mapper.s_firm(params);
        s_firm.setSelectNone("所有");
        result.put("s_firm", s_firm);
        
        
        SQLList<SQLMap> p_quote=mapper.p_quote(params,pagination);
        p_quote.setPagedListInfo(pagination);
        result.put("p_quote", p_quote);
        
        return result;
    }
    /**
    盘存差异商品
    */
    
    public Map inventoryDifList() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_quote=mapper.s_quote(params);
        SQLMap s_quote_emt=s_quote.getExistfirst();
        result.put("s_quote", s_quote_emt);
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params);
        result.put("s_product", s_product);
        
        return result;
    }
    /**
    批量盘存商品
    */
    
    public Map inventoryDifBat() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_quote=mapper.s_quote(params);
        SQLMap s_quote_emt=s_quote.getExistfirst();
        result.put("s_quote", s_quote_emt);
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params);
        result.put("s_product", s_product);
        
        return result;
    }
    /**
    盘存增加记录
    */
    
    public Map inventoryInsert() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_firm=mapper.s_firm(params);
        result.put("s_firm", s_firm);
        
        
        SQLList<SQLMap> s_set=mapper.s_set(params);
        result.put("s_set", s_set);
        
        return result;
    }
    /**
    盘存明细
    */
    
    public Map inventoryDetile() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_quote=mapper.s_quote(params);
        SQLMap s_quote_emt=s_quote.getExistfirst();
        result.put("s_quote", s_quote_emt);
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params);
        result.put("s_product", s_product);
        
        return result;
    }
    /**
    盘存
    */
    
    public Map inventoryManage() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> l_goods=mapper.l_goods(params);
        result.put("l_goods", l_goods);
        
        return result;
    }
    /**
    盘存记录
    */
    
    public Map inventoryRecord() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> p_product=mapper.p_product(params,pagination);
        p_product.setPagedListInfo(pagination);
        result.put("p_product", p_product);
        
        return result;
    }
    public void onvalidate(){
    }
    /**
    */
    
    public Map d_quote() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_quote(params);
        
        return result;
    }
    /**
    */
    
    public Map d_store() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_store(params);
        
        return result;
    }
    /**
    盘存增加修改
    */
    
    public Map inventoryAddSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID = mapper.CMID(params);
        result.put("CMID", CMID);
        
        
        int i = mapper.i(params);
        result.put("i", i);
        
        
        Object implement_id =
        mapper.implement_id(params);
        result.put("implement_id", implement_id);
        
        
        int i2 = mapper.i2(params);
        result.put("i2", i2);
        
        
        mapper.inventoryAddSubmit(params);
        
        
        mapper.inventoryAddSubmit(params);
        
        
        
        
        
        
        
        return result;
    }
    /**
    */
    
    public Map d_product() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_product(params);
        
        return result;
    }
    /**
    搜索增加物料修改
    */
    
    public Map searchProSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.searchProSubmit(params);
        }
        
        return result;
    }
    /**
    替换库管员修改
    */
    
    public Map replaceLibSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.replaceLibSubmit(params);
        
        return result;
    }
    /**
    盘存执行详情修改
    */
    
    public Map inventoryDetSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        return result;
    }
    /**
    盘存执行列表修改
    */
    
    public Map inventoryImpSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.inventoryImpSubmit(params);
        
        
        mapper.inventoryImpSubmit(params);
        
        return result;
    }
    /**
    盘存物料详情修改
    */
    
    public Map proDetSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.proDetSubmit(params);
        
        return result;
    }
    /**
    差异报告列表修改
    */
    
    public Map diffRepSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.diffRepSubmit(params);
        
        return result;
    }
    /**
    差异报告详情修改
    */
    
    public Map differenceReportDetailsSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.differenceReportDetailsSubmit(params);
        
        return result;
    }
    /**
    库管员处理列表修改
    */
    
    public Map inventoryLibDiffSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.inventoryLibDiffSubmit(params);
        
        
        mapper.inventoryLibDiffSubmit(params);
        
        
        mapper.inventoryLibDiffSubmit(params);
        
        return result;
    }
    /**
    */
    
    public Map d_pstock() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_pstock(params);
        
        return result;
    }
    /**
    库管员选择出入单修改
    */
    
    public Map choiceEntryExitSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.choiceEntryExitSubmit(params);
        }
        
        
        mapper.choiceEntryExitSubmit(params);
        
        return result;
    }
    /**
    库管组长处理列表修改
    */
    
    public Map inventoryLeaProHabSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.inventoryLeaProHabSubmit(params);
        
        
        mapper.inventoryLeaProHabSubmit(params);
        
        
        mapper.inventoryLeaProHabSubmit(params);
        
        return result;
    }
    /**
    */
    
    public Map c_product() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.c_product(params);
        
        return result;
    }
    /**
    */
    
    public Map n_product() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.n_product(params);
        
        return result;
    }
    /**
    财务经理审批列表修改
    */
    
    public Map finManAprSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.finManAprSubmit(params);
        
        
        mapper.finManAprSubmit(params);
        
        
        mapper.finManAprSubmit(params);
        
        return result;
    }
    /**
    财务经理审批详情修改
    */
    
    public Map financialApprovalDetSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.financialApprovalDetSubmit(params);
        
        return result;
    }
    /**
    成本会计处理列表修改
    */
    
    public Map accoutTreaSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.accoutTreaSubmit(params);
        
        
        mapper.accoutTreaSubmit(params);
        
        
        mapper.accoutTreaSubmit(params);
        
        return result;
    }
    /**
    会计选择出入单修改
    */
    
    public Map approvalChioceEntryExitSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.approvalChioceEntryExitSubmit(params);
        }
        
        
        mapper.approvalChioceEntryExitSubmit(params);
        
        return result;
    }
    /**
    财务经理确认列表修改
    */
    
    public Map finManConfirmSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.finManConfirmSubmit(params);
        
        
        mapper.finManConfirmSubmit(params);
        
        return result;
    }
    /**
    财务经理确认详情修改
    */
    
    public Map financialConfirmDetSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.financialConfirmDetSubmit(params);
        
        
        
        return result;
    }
    /**
    盘存记录修改修改
    */
    
    public Map inventoryUpSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.inventoryUpSubmit(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.inventoryUpSubmit(params);
        }
        
        return result;
    }
    /**
    盘存记录详情修改修改
    */
    
    public Map inventoryUpDetSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.inventoryUpDetSubmit(params);
        
        
        mapper.inventoryUpDetSubmit(params);
        
        return result;
    }
    /**
    库管员盘存页面修改
    */
    
    public Map inventoryProSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.inventoryProSubmit(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.inventoryProSubmit(params);
        }
        
        return result;
    }
    /**
    盘存差异商品修改
    */
    
    public Map inventoryDifListSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.inventoryDifListSubmit(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            if(SQL.isNotNull(params.get("product_id"))&&SQL.isNotNull(params.get("take_num")))
            mapper.inventoryDifListSubmit(params);
        }
        
        return result;
    }
    /**
    批量盘存商品修改
    */
    
    public Map inventoryDifBatSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.inventoryDifBatSubmit(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.inventoryDifBatSubmit(params);
        }
        
        return result;
    }
    /**
    盘存增加记录修改
    */
    
    public Map inventoryInsertSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID = mapper.CMID(params);
        result.put("CMID", CMID);
        
        
        
        
        
        return result;
    }
    public Map ajaxList(){
        String sql="";
        String pagesql="";
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        if(request.getParameter("cfield_name").contains("set_id")){
            SQLList<SQLMap> set_id=mapper.set_id(params);
            result.put("set_id", set_id);
        }
        
        return result;
    }
}